Под заказ: 3
Терминал доступный
При оплате картой взимается комиссия 1%
Ширина: | 245 |
Высота: | 40 |
Диаметр: | 19 |
Индекс скорости: | 98T |
Сезонность: | Зимняя |
Шипы: | Шипованная |
Ikon Nordman 5 - это высококачественные зимние шины, созданные на базе технологий Nokian Tyres, предназначенные для обеспечения безопасности и комфорта на зимних дорогах по доступной цене.
Преимущества:
Ikon Nordman 5 - это:
Ikon Nordman 5 - выбор для тех, кто ищет надежные и комфортные зимние шины по доступной цене!
Применение:
Ikon Nordman 5 идеально подходят для широкого спектра легковых автомобилей, от седанов и хэтчбеков до кроссоверов, обеспечивая оптимальную производительность и безопасность на зимних дорогах.
Доступные размеры: Широкий ассортимент размеров для различных моделей автомобилей.
Купить зимние шипованные шины Ikon Nordman 5 в Волгограде можно в магазине Автошина34.
Michelin X-Ice North 4 245/40 R19 98T шип
Marshal WinterCraft Ice WI31 245/40 R19 98T шип
Hankook Winter i*Pike RS2 W429 245/40 R19 98T шип
Введите свой номер и мы перезвоним Вам
Товар был добавлен в корзину. Вы можете продолжить покупки или перейти к оформлению заказа
Вы нашли этот товар дешевле? Расскажите об этом
Условия акции:
Необходимо предоставить ссылку на сайт с данным товаром и конкурент должен быть из
Волгограда.
Чтобы избежать томительного ожидания в очереди около шиномонтажа Вы можете предварительно записаться у нас. Менеджер свяжется с Вами и уточнит все детали.
1 x Application (98.65%) | 873.09ms |
1 x Booting (1.34%) | 11.82ms |
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
select * from `categories` where (`parent` = 1 and `tmp` = '0' and `visible` = 1) order by `categories`.`order` asc
630μs/app/Models/Product/Category.php:158avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `car_manufacturers` order by `name` asc
420μsmiddleware::client:22avtoshina_betaMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `seo_redirects` where `page_from` = 'catalog/getPromoBlock' limit 1
260μs/app/Models/Redirect.php:33avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `title`, `h1`, `description`, `keywords` from `seo` where `page_url` = 'catalog/getPromoBlock' limit 1
200μs/app/Models/Seo.php:36avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `suppliers` where `type` = 'store'
160μs/app/Models/Product/Product.php:1323avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `products` where `id` = '527235' limit 1
350μs/app/Models/Product/Product.php:1240avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `tyres` where `product_id` = '527235' limit 1
290μs/app/Models/Product/Product.php:1246avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product`.`id` as `product_id`, `product`.`alias` as `product_alias`, `product`.`manufacturer_id`, `product`.`card_name` as `product_name`, `product`.`product_type`, `category`.`alias` as `category_alias`, `category`.`name` as `category_name`, `product`.`category_id`, `category`.`parent` as `category_parent`, `manufacturer`.`name` as `manufacturer_name`, `manufacturer`.`alias` as `manufacturer_alias`, `store`.`store_sum`,
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id = 13
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id = 13
)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id IN (12,13)
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id IN (12,13)
LIMIT 1)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
)
THEN
FLOOR((store.price * (100 - (SELECT discount
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
LIMIT 1)) / 100) / 10) * 10
ELSE
store.store_min_price
END
END
END AS main_price
, `suppliers`.`type` from `products` as `product` left join `manufacturers` as `manufacturer` on `product`.`manufacturer_id` = `manufacturer`.`id` inner join `categories` as `category` on `product`.`category_id` = `category`.`id` left join (
SELECT
product_id,
supplier_id,
price, discount_price,
sum(product_store.quantity) as store_sum,
min(product_store.price) as store_min_price
FROM product_store
WHERE quantity > 0 AND price > 0
GROUP BY product_id, supplier_id, price, discount_price) AS store on `product`.`id` = `store`.`product_id` and `product`.`min_price_supplier_id` = `store`.`supplier_id` left join `suppliers` on `supplier_id` = `suppliers`.`id` inner join `tyres` on `product`.`id` = `tyres`.`product_id` where (`product`.`visible` = 1 and `product`.`tmp` = 0) and (`category`.`tmp` = 0 and `category`.`visible` = 1) and `product`.`manufacturer_id` is not null and (manufacturer.visible IS NULL OR manufacturer.visible = 1) and (store_sum IS NOT NULL AND store_sum > 0) and `tyres`.`diameter` = 19 and `tyres`.`width` = 245 and `tyres`.`height` = 40 and `tyres`.`season` = 1 and `tyres`.`is_spike` = 1
620μs/app/Models/Product/Product.php:1256avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product`.`id` as `product_id`, `product`.`alias` as `product_alias`, `product`.`manufacturer_id`, `product`.`card_name` as `product_name`, `product`.`product_type`, `category`.`alias` as `category_alias`, `category`.`name` as `category_name`, `product`.`category_id`, `category`.`parent` as `category_parent`, `manufacturer`.`name` as `manufacturer_name`, `manufacturer`.`alias` as `manufacturer_alias`, `store`.`store_sum`,
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id = 13
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id = 13
)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id IN (12,13)
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id IN (12,13)
LIMIT 1)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
)
THEN
FLOOR((store.price * (100 - (SELECT discount
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
LIMIT 1)) / 100) / 10) * 10
ELSE
store.store_min_price
END
END
END AS main_price
, `suppliers`.`type` from `products` as `product` left join `manufacturers` as `manufacturer` on `product`.`manufacturer_id` = `manufacturer`.`id` inner join `categories` as `category` on `product`.`category_id` = `category`.`id` left join (
SELECT
product_id,
supplier_id,
price, discount_price,
sum(product_store.quantity) as store_sum,
min(product_store.price) as store_min_price
FROM product_store
WHERE quantity > 0 AND price > 0
GROUP BY product_id, supplier_id, price, discount_price) AS store on `product`.`id` = `store`.`product_id` and `product`.`min_price_supplier_id` = `store`.`supplier_id` left join `suppliers` on `supplier_id` = `suppliers`.`id` inner join `tyres` on `product`.`id` = `tyres`.`product_id` where (`product`.`visible` = 1 and `product`.`tmp` = 0) and (`category`.`tmp` = 0 and `category`.`visible` = 1) and `product`.`manufacturer_id` is not null and (manufacturer.visible IS NULL OR manufacturer.visible = 1) and (store_sum IS NOT NULL AND store_sum > 0) and `tyres`.`diameter` = 19 and `tyres`.`width` = 245 and `tyres`.`height` = 40 and `tyres`.`season` = 1 and `tyres`.`is_spike` = 1 and `product`.`id` <> '527235' limit 5
658ms/app/Models/Product/Product.php:1295avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `product_images` where `product_id` in (144343, 536403, 600638, 684103, 695570)
1.64ms/app/Libraries/ProductHelper.php:30avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `season` from `tyres` where `product_id` in (144343, 536403, 600638, 684103, 695570)
220μs/app/Libraries/ProductHelper.php:33avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `product_id`, `model`, `width`, `height`, `diameter`, `speed_index`, `is_spike` from `tyres` where `product_id` in (144343, 536403, 600638, 684103, 695570)
190μs/app/Libraries/ProductHelper.php:36avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `products` where (`id` = 144343) limit 1
500μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (144343)
360μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (35, 39, 42)
590μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3, 7, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
560μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 536403) limit 1
260μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (536403)
200μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
200μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 600638) limit 1
310μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (600638)
260μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (35, 39, 42, 46)
770μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3, 7, 12, 16) and `images`.`imageable_type` = 'App\Models\PromoTag'
320μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
250μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 684103) limit 1
250μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (684103)
240μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
260μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
160μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 695570) limit 1
240μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (695570)
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
250μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
210μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
400μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`product_id`, `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`days` as `days`, CASE
WHEN product_redprice.discount IS NOT NULL
THEN
FLOOR((product_store.price * (100 - product_redprice.discount) / 100) / 10) * 10
ELSE
product_store.price
END AS minprice from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` left join `product_redprice` on `product_store`.`product_id` = `product_redprice`.`product_id` and `product_store`.`supplier_id` = `product_redprice`.`supplier_id` where `product_store`.`product_id` in (144343, 536403, 600638, 684103, 695570) and `product_store`.`quantity` > 0 and `product_store`.`price` > 0 order by `minprice` asc
310μs/app/Libraries/ProductHelper.php:93avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 144343 order by `suppliers`.`type` desc
230μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '249604' and `supplier_id` = 5) and `quantity` > 0 limit 1
230μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '87994706056' and `supplier_id` = 8) and `quantity` > 0 limit 1
460μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 144343 and `supplier_id` = 8)
210μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '861812' and `supplier_id` = 2) and `quantity` > 0 limit 1
230μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '861812' and `supplier_id` = 3) and `quantity` > 0 limit 1
210μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '861812' and `supplier_id` = 10) and `quantity` > 0 limit 1
290μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '249604' and `supplier_id` = 11) and `quantity` > 0 limit 1
200μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 144343 and `supplier_id` = 11)
230μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 536403 order by `suppliers`.`type` desc
320μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '98076' and `supplier_id` = 2) and `quantity` > 0 limit 1
220μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 536403 and `supplier_id` = 2)
160μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '831531' and `supplier_id` = 10) and `quantity` > 0 limit 1
250μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '87372347489' and `supplier_id` = 8) and `quantity` > 0 limit 1
230μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 600638 order by `suppliers`.`type` desc
220μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '27233' and `supplier_id` = 1) and `quantity` > 0 limit 1
200μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '1488652' and `supplier_id` = 11) and `quantity` > 0 limit 1
250μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '1488652' and `supplier_id` = 10) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '1032097' and `supplier_id` = 5) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '1032097' and `supplier_id` = 11) and `quantity` > 0 limit 1
150μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 600638 and `supplier_id` = 11)
320μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 684103 order by `suppliers`.`type` desc
460μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '1071174' and `supplier_id` = 10) and `quantity` > 0 limit 1
210μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'R6797' and `supplier_id` = 5) and `quantity` > 0 limit 1
220μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'R6797' and `supplier_id` = 11) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 684103 and `supplier_id` = 11)
200μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '95694585224' and `supplier_id` = 8) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '98450' and `supplier_id` = 2) and `quantity` > 0 limit 1
180μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 684103 and `supplier_id` = 2)
150μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 695570 order by `suppliers`.`type` desc
230μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '1044606' and `supplier_id` = 10) and `quantity` > 0 limit 1
250μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '0349051' and `supplier_id` = 11) and `quantity` > 0 limit 1
260μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 695570 and `supplier_id` = 11)
160μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `path`, `manufacturer_id` from `manufacturer_images` where `manufacturer_images`.`manufacturer_id` in (65, 83, 68, 67, 72)
190μs/app/Libraries/ProductHelper.php:117avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `suppliers` where `type` = 'store'
180μs/app/Models/Product/Product.php:1323avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select distinct `product`.`id` as `product_id`, `product`.`alias` as `product_alias`, `product`.`manufacturer_id`, `product`.`card_name` as `product_name`, `product`.`product_type`, `category`.`alias` as `category_alias`, `category`.`name` as `category_name`, `product`.`category_id`, `category`.`parent` as `category_parent`, `manufacturer`.`name` as `manufacturer_name`, `manufacturer`.`alias` as `manufacturer_alias`, `store`.`store_sum`,
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id = 13
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id = 13
)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id IN (12,13)
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id IN (12,13)
LIMIT 1)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
)
THEN
FLOOR((store.price * (100 - (SELECT discount
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
LIMIT 1)) / 100) / 10) * 10
ELSE
store.store_min_price
END
END
END AS main_price
, `suppliers`.`type` from `products` as `product` left join `manufacturers` as `manufacturer` on `product`.`manufacturer_id` = `manufacturer`.`id` inner join `categories` as `category` on `product`.`category_id` = `category`.`id` left join (
SELECT
product_id,
supplier_id,
price, discount_price,
sum(product_store.quantity) as store_sum,
min(product_store.price) as store_min_price
FROM product_store
WHERE quantity > 0 AND price > 0
GROUP BY product_id, supplier_id, price, discount_price) AS store on `product`.`id` = `store`.`product_id` and `product`.`min_price_supplier_id` = `store`.`supplier_id` left join `suppliers` on `supplier_id` = `suppliers`.`id` left join `product_images` on `product`.`id` = `product_images`.`product_id` left join `product_redprice` on `product`.`id` = `product_redprice`.`product_id` left join `product_store` on `product`.`id` = `product_store`.`product_id` where (`product`.`visible` = 1 and `product`.`tmp` = 0) and (`category`.`tmp` = 0 and `category`.`visible` = 1) and `product`.`manufacturer_id` is not null and (manufacturer.visible IS NULL OR manufacturer.visible = 1) and (store_sum IS NOT NULL AND store_sum > 0) and (`product_store`.`discount_price` > 0 and `product_store`.`price` > `product_store`.`discount_price` or `product`.`id` = `product_redprice`.`product_id` and `store`.`supplier_id` = `product_redprice`.`supplier_id`) limit 15
730μs/app/Models/Product/Product.php:1197avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `product_images` where `product_id` in (8002, 8120, 356988, 357335, 422430, 422442, 422786, 422881, 490215, 490216, 522537, 522597, 522598, 522910, 522921)
200μs/app/Libraries/ProductHelper.php:30avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 8002) limit 1
200μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (8002)
270μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (39, 42)
600μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'
270μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
250μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 8120) limit 1
270μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (8120)
450μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
250μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
360μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
360μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 356988) limit 1
260μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (356988)
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
200μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
200μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 357335) limit 1
390μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (357335)
200μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
260μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
230μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 422430) limit 1
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (422430)
210μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
230μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
330μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
260μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 422442) limit 1
230μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (422442)
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
260μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
160μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
270μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 422786) limit 1
250μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (422786)
260μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
300μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
430μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
200μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 422881) limit 1
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (422881)
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
310μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
210μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 490215) limit 1
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (490215)
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (39, 42)
570μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'
160μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
170μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 490216) limit 1
150μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (490216)
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
240μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
150μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
230μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 522537) limit 1
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (522537)
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
280μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
180μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 522597) limit 1
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (522597)
270μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
240μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
220μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 522598) limit 1
200μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (522598)
210μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
230μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
170μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 522910) limit 1
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (522910)
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
230μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
200μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 522921) limit 1
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (522921)
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)
600μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
280μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`product_id`, `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`days` as `days`, CASE
WHEN product_redprice.discount IS NOT NULL
THEN
FLOOR((product_store.price * (100 - product_redprice.discount) / 100) / 10) * 10
ELSE
product_store.price
END AS minprice from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` left join `product_redprice` on `product_store`.`product_id` = `product_redprice`.`product_id` and `product_store`.`supplier_id` = `product_redprice`.`supplier_id` where `product_store`.`product_id` in (8002, 8120, 356988, 357335, 422430, 422442, 422786, 422881, 490215, 490216, 522537, 522597, 522598, 522910, 522921) and `product_store`.`quantity` > 0 and `product_store`.`price` > 0 order by `minprice` asc
410μs/app/Libraries/ProductHelper.php:93avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 8002 order by `suppliers`.`type` desc
240μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tz-2030' and `supplier_id` = 13) and `quantity` > 0 limit 1
300μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 8002 and `supplier_id` = 13)
250μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 8120 order by `suppliers`.`type` desc
300μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-0435' and `supplier_id` = 13) and `quantity` > 0 limit 1
300μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 8120 and `supplier_id` = 13)
150μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 356988 order by `suppliers`.`type` desc
210μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS158817' and `supplier_id` = 5) and `quantity` > 0 limit 1
300μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS158817' and `supplier_id` = 11) and `quantity` > 0 limit 1
180μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 356988 and `supplier_id` = 11)
190μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 357335 order by `suppliers`.`type` desc
200μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-40020' and `supplier_id` = 13) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-40020' and `supplier_id` = 12) and `quantity` > 0 limit 1
160μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 357335 and `supplier_id` = 12)
150μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS209646' and `supplier_id` = 5) and `quantity` > 0 limit 1
160μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS209646' and `supplier_id` = 11) and `quantity` > 0 limit 1
200μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 422430 order by `suppliers`.`type` desc
220μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221916' and `supplier_id` = 5) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422430 and `supplier_id` = 5)
150μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221916' and `supplier_id` = 11) and `quantity` > 0 limit 1
210μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422430 and `supplier_id` = 11)
190μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '000000571' and `supplier_id` = 4) and `quantity` > 0 limit 1
200μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422430 and `supplier_id` = 4)
150μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 422442 order by `suppliers`.`type` desc
240μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221899' and `supplier_id` = 5) and `quantity` > 0 limit 1
300μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '980860' and `supplier_id` = 10) and `quantity` > 0 limit 1
180μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221899' and `supplier_id` = 11) and `quantity` > 0 limit 1
130μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422442 and `supplier_id` = 11)
120μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '137556' and `supplier_id` = 9) and `quantity` > 0 limit 1
160μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 422786 order by `suppliers`.`type` desc
250μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221893' and `supplier_id` = 5) and `quantity` > 0 limit 1
230μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422786 and `supplier_id` = 5)
150μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221893' and `supplier_id` = 11) and `quantity` > 0 limit 1
340μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422786 and `supplier_id` = 11)
170μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 422881 order by `suppliers`.`type` desc
200μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221898' and `supplier_id` = 5) and `quantity` > 0 limit 1
200μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221898' and `supplier_id` = 11) and `quantity` > 0 limit 1
150μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422881 and `supplier_id` = 11)
160μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 490215 order by `suppliers`.`type` desc
200μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-X40927' and `supplier_id` = 13) and `quantity` > 0 limit 1
140μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 490215 and `supplier_id` = 13)
120μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '000088351' and `supplier_id` = 4) and `quantity` > 0 limit 1
370μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 490216 order by `suppliers`.`type` desc
380μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-8667' and `supplier_id` = 13) and `quantity` > 0 limit 1
220μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 490216 and `supplier_id` = 13)
170μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 522537 order by `suppliers`.`type` desc
190μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '1098050' and `supplier_id` = 10) and `quantity` > 0 limit 1
250μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'УТ-00009432' and `supplier_id` = 9) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '97086' and `supplier_id` = 2) and `quantity` > 0 limit 1
260μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '88254384560' and `supplier_id` = 8) and `quantity` > 0 limit 1
190μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522537 and `supplier_id` = 8)
190μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 522597 order by `suppliers`.`type` desc
200μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS500776' and `supplier_id` = 5) and `quantity` > 0 limit 1
140μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS500776' and `supplier_id` = 11) and `quantity` > 0 limit 1
130μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522597 and `supplier_id` = 11)
130μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 522598 order by `suppliers`.`type` desc
200μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS503030' and `supplier_id` = 5) and `quantity` > 0 limit 1
190μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522598 and `supplier_id` = 5)
170μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS503030' and `supplier_id` = 11) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522598 and `supplier_id` = 11)
140μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'НФ-00014836' and `supplier_id` = 4) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522598 and `supplier_id` = 4)
130μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '81121' and `supplier_id` = 2) and `quantity` > 0 limit 1
150μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522598 and `supplier_id` = 2)
120μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 522910 order by `suppliers`.`type` desc
370μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-7368' and `supplier_id` = 13) and `quantity` > 0 limit 1
190μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522910 and `supplier_id` = 13)
140μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'НФ-00007200' and `supplier_id` = 4) and `quantity` > 0 limit 1
130μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522910 and `supplier_id` = 4)
110μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS083584' and `supplier_id` = 5) and `quantity` > 0 limit 1
120μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS083584' and `supplier_id` = 11) and `quantity` > 0 limit 1
120μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 522921 order by `suppliers`.`type` desc
210μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS229143' and `supplier_id` = 5) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522921 and `supplier_id` = 5)
260μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS229143' and `supplier_id` = 11) and `quantity` > 0 limit 1
240μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522921 and `supplier_id` = 11)
210μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `path`, `manufacturer_id` from `manufacturer_images` where `manufacturer_images`.`manufacturer_id` in (21, 255, 23, 23, 21, 21, 21, 21, 23, 23, 23, 21, 21, 23, 23)
210μs/app/Libraries/ProductHelper.php:117avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `suppliers` where `type` = 'store'
170μs/app/Models/Product/Product.php:1323avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product`.`id` as `product_id`, `product`.`alias` as `product_alias`, `product`.`manufacturer_id`, `product`.`card_name` as `product_name`, `product`.`product_type`, `category`.`alias` as `category_alias`, `category`.`name` as `category_name`, `product`.`category_id`, `category`.`parent` as `category_parent`, `manufacturer`.`name` as `manufacturer_name`, `manufacturer`.`alias` as `manufacturer_alias`, `store`.`store_sum`,
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id = 13
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id = 13
)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id IN (12,13)
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id IN (12,13)
LIMIT 1)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
)
THEN
FLOOR((store.price * (100 - (SELECT discount
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
LIMIT 1)) / 100) / 10) * 10
ELSE
store.store_min_price
END
END
END AS main_price
, `suppliers`.`type` from `products` as `product` left join `manufacturers` as `manufacturer` on `product`.`manufacturer_id` = `manufacturer`.`id` inner join `categories` as `category` on `product`.`category_id` = `category`.`id` left join (
SELECT
product_id,
supplier_id,
price, discount_price,
sum(product_store.quantity) as store_sum,
min(product_store.price) as store_min_price
FROM product_store
WHERE quantity > 0 AND price > 0
GROUP BY product_id, supplier_id, price, discount_price) AS store on `product`.`id` = `store`.`product_id` and `product`.`min_price_supplier_id` = `store`.`supplier_id` left join `suppliers` on `supplier_id` = `suppliers`.`id` inner join `product_to_promo` on `product`.`id` = `product_to_promo`.`product_id` inner join `promo_tags` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where (`product`.`visible` = 1 and `product`.`tmp` = 0) and (`category`.`tmp` = 0 and `category`.`visible` = 1) and `product`.`manufacturer_id` is not null and (manufacturer.visible IS NULL OR manufacturer.visible = 1) and (store_sum IS NOT NULL AND store_sum > 0) and `promo_tags`.`code` = 'profit' order by `product`.`profit_order` desc, `product_to_promo`.`created_at` desc limit 5
800μs/app/Models/Product/Product.php:1226avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` in (520509, 526837, 393375, 525747, 84824)
190μs/app/Libraries/ProductHelper.php:30avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `season` from `tyres` where `product_id` in (520509, 526837, 393375, 525747, 84824)
170μs/app/Libraries/ProductHelper.php:33avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `product_id`, `model`, `width`, `height`, `diameter`, `speed_index`, `is_spike` from `tyres` where `product_id` in (520509, 526837, 393375, 525747, 84824)
180μs/app/Libraries/ProductHelper.php:36avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `products` where (`id` = 520509) limit 1
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (520509)
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)
720μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
180μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 526837) limit 1
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (526837)
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)
530μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
190μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 393375) limit 1
200μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (393375)
270μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)
550μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
180μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 525747) limit 1
260μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (525747)
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)
570μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
240μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 84824) limit 1
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (84824)
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)
510μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'
180μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
180μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`product_id`, `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`days` as `days`, CASE
WHEN product_redprice.discount IS NOT NULL
THEN
FLOOR((product_store.price * (100 - product_redprice.discount) / 100) / 10) * 10
ELSE
product_store.price
END AS minprice from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` left join `product_redprice` on `product_store`.`product_id` = `product_redprice`.`product_id` and `product_store`.`supplier_id` = `product_redprice`.`supplier_id` where `product_store`.`product_id` in (520509, 526837, 393375, 525747, 84824) and `product_store`.`quantity` > 0 and `product_store`.`price` > 0 order by `minprice` asc
330μs/app/Libraries/ProductHelper.php:93avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 520509 order by `suppliers`.`type` desc
190μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '75997' and `supplier_id` = 2) and `quantity` > 0 limit 1
230μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'TS32281' and `supplier_id` = 11) and `quantity` > 0 limit 1
150μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 520509 and `supplier_id` = 11)
190μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 526837 order by `suppliers`.`type` desc
250μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'T430095' and `supplier_id` = 5) and `quantity` > 0 limit 1
150μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '113401' and `supplier_id` = 9) and `quantity` > 0 limit 1
130μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 526837 and `supplier_id` = 9)
120μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 393375 order by `suppliers`.`type` desc
190μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '87362869028' and `supplier_id` = 5) and `quantity` > 0 limit 1
260μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '800002783' and `supplier_id` = 9) and `quantity` > 0 limit 1
240μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 393375 and `supplier_id` = 9)
140μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '20884' and `supplier_id` = 1) and `quantity` > 0 limit 1
190μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 525747 order by `suppliers`.`type` desc
210μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'TS32710' and `supplier_id` = 5) and `quantity` > 0 limit 1
140μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'TS32710' and `supplier_id` = 11) and `quantity` > 0 limit 1
150μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '93882135977' and `supplier_id` = 8) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 525747 and `supplier_id` = 8)
150μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 84824 order by `suppliers`.`type` desc
190μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '820941' and `supplier_id` = 10) and `quantity` > 0 limit 1
180μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '69924' and `supplier_id` = 2) and `quantity` > 0 limit 1
140μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 84824 and `supplier_id` = 2)
120μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '15434' and `supplier_id` = 1) and `quantity` > 0 limit 1
130μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'TS32198' and `supplier_id` = 11) and `quantity` > 0 limit 1
130μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `path`, `manufacturer_id` from `manufacturer_images` where `manufacturer_images`.`manufacturer_id` in (64, 64, 64, 64, 64)
210μs/app/Libraries/ProductHelper.php:117avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id` from `suppliers` where `type` = 'store'
160μs/app/Models/Product/Product.php:1323avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product`.`id` as `product_id`, `product`.`alias` as `product_alias`, `product`.`manufacturer_id`, `product`.`card_name` as `product_name`, `product`.`product_type`, `category`.`alias` as `category_alias`, `category`.`name` as `category_name`, `product`.`category_id`, `category`.`parent` as `category_parent`, `manufacturer`.`name` as `manufacturer_name`, `manufacturer`.`alias` as `manufacturer_alias`, `store`.`store_sum`,
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id = 13
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id = 13
)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id IN (12,13)
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id IN (12,13)
LIMIT 1)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
)
THEN
FLOOR((store.price * (100 - (SELECT discount
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
LIMIT 1)) / 100) / 10) * 10
ELSE
store.store_min_price
END
END
END AS main_price
, `suppliers`.`type` from `products` as `product` left join `manufacturers` as `manufacturer` on `product`.`manufacturer_id` = `manufacturer`.`id` inner join `categories` as `category` on `product`.`category_id` = `category`.`id` left join (
SELECT
product_id,
supplier_id,
price, discount_price,
sum(product_store.quantity) as store_sum,
min(product_store.price) as store_min_price
FROM product_store
WHERE quantity > 0 AND price > 0
GROUP BY product_id, supplier_id, price, discount_price) AS store on `product`.`id` = `store`.`product_id` and `product`.`min_price_supplier_id` = `store`.`supplier_id` left join `suppliers` on `supplier_id` = `suppliers`.`id` inner join `product_to_promo` on `product`.`id` = `product_to_promo`.`product_id` inner join `promo_tags` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where (`product`.`visible` = 1 and `product`.`tmp` = 0) and (`category`.`tmp` = 0 and `category`.`visible` = 1) and `product`.`manufacturer_id` is not null and (manufacturer.visible IS NULL OR manufacturer.visible = 1) and (store_sum IS NOT NULL AND store_sum > 0) and `promo_tags`.`code` = 'recommend' order by `product`.`recommend_order` desc, `product_to_promo`.`created_at` desc limit 5
770μs/app/Models/Product/Product.php:1226avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` in (774840, 774839, 774838, 774837, 774836)
180μs/app/Libraries/ProductHelper.php:30avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `categories` where `id` = 7 limit 1
220μs/app/Models/Product/Category.php:203avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 774840) limit 1
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774840)
200μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)
210μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'
170μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
230μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `categories` where `id` = 7 limit 1
280μs/app/Models/Product/Category.php:203avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 774839) limit 1
200μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774839)
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)
290μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
460μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `categories` where `id` = 7 limit 1
270μs/app/Models/Product/Category.php:203avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 774838) limit 1
270μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774838)
230μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)
260μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'
150μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
300μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `categories` where `id` = 7 limit 1
150μs/app/Models/Product/Category.php:203avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 774837) limit 1
250μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774837)
190μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)
240μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'
230μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
210μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `categories` where `id` = 7 limit 1
170μs/app/Models/Product/Category.php:203avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `products` where (`id` = 774836) limit 1
220μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774836)
210μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)
440μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'
230μs/app/Libraries/ProductHelper.php:63avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-02-24 14:33:29' and `to` >= '2025-02-24 14:33:29'
220μs/app/Models/Promocode.php:100avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `product_store`.`product_id`, `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`days` as `days`, CASE
WHEN product_redprice.discount IS NOT NULL
THEN
FLOOR((product_store.price * (100 - product_redprice.discount) / 100) / 10) * 10
ELSE
product_store.price
END AS minprice from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` left join `product_redprice` on `product_store`.`product_id` = `product_redprice`.`product_id` and `product_store`.`supplier_id` = `product_redprice`.`supplier_id` where `product_store`.`product_id` in (774840, 774839, 774838, 774837, 774836) and `product_store`.`quantity` > 0 and `product_store`.`price` > 0 order by `minprice` asc
330μs/app/Libraries/ProductHelper.php:93avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774840 order by `suppliers`.`type` desc
240μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-0799' and `supplier_id` = 12) and `quantity` > 0 limit 1
190μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774840 and `supplier_id` = 12)
240μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774839 order by `suppliers`.`type` desc
500μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-0589' and `supplier_id` = 12) and `quantity` > 0 limit 1
230μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774839 and `supplier_id` = 12)
170μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774838 order by `suppliers`.`type` desc
290μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-0588' and `supplier_id` = 12) and `quantity` > 0 limit 1
190μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774838 and `supplier_id` = 12)
150μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774837 order by `suppliers`.`type` desc
320μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-1815' and `supplier_id` = 12) and `quantity` > 0 limit 1
230μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774837 and `supplier_id` = 12)
170μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774836 order by `suppliers`.`type` desc
300μs/app/Models/Product/ProductStore.php:51avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-0401' and `supplier_id` = 12) and `quantity` > 0 limit 1
170μs/app/Models/Product/ProductStore.php:167avtoshina_betaMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774836 and `supplier_id` = 12)
150μs/app/Models/Product/ProductStore.php:173avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `path`, `manufacturer_id` from `manufacturer_images` where `manufacturer_images`.`manufacturer_id` in (443, 443, 443, 443, 443)
170μs/app/Libraries/ProductHelper.php:117avtoshina_betaMetadata | |
---|---|
Bindings |
|
Backtrace |
|
200
0 of 0array:1 [▶ "id" => "527235" ]
0 of 0array:1 [▶ "id" => "527235" ]
0 of 0array:19 [▶ "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjZFc0JXc0NuaHlLUjhlWGFudER6ZFE9PSIsInZhbHVlIjoidjk2S1lXYjVFYVc4ZmxGWlNCMzZqSWhlNmJHa3pDNWlDMjdHS1BuWDVSYmtZTFFQa0cxY3dPTDlRUjVvU09jMiIsIm1hYyI6ImNlZDU4NTYxOTQ5YzFjYTk3YzQyODExZDY4MTllMThiMGY5NTNmZWE0NzM0MzQzMzg0MzA5YmYyNjMzZjcyNDUifQ%3D%3D; laravel_session=eyJpdiI6ImpGcWJvTG5cL1piRXh5eWRUZGVReGpRPT0iLCJ2YWx1ZSI6ImdJdG15VFRwaWMwVUtacXZpY2U4MThJTDVubjZcL3JtUmRlT3A4TDB0SGJaYWdBODhSVEV0UUJhT1dybUxUZVwvM002VXN3dGVcL0NKbmNXZWV6NjF0emZ5V2liWEQ0REJhaWNtOUZDS1wvV3NuUThnTDdaZXdZNndjcUwzVFdia1cxMyIsIm1hYyI6ImJhMjhiZWM1M2FlMTEyNzFmZjQ2ODUzYmQ0ZGZlNTFlMGY2NDFlY2MxNzU2YThhZTNjMWVlYjZlZmI2NjNlMGUifQ%3D%3D ◀XSRF-TOKEN=eyJpdiI6IjZFc0JXc0NuaHlLUjhlWGFudER6ZFE9PSIsInZhbHVlIjoidjk2S1lXYjVFYVc4ZmxGWlNCMzZqSWhlNmJHa3pDNWlDMjdHS1BuWDVSYmtZTFFQa0cxY3dPTDlRUjVvU09jMiIsIm1hY ▶" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "referer" => array:1 [▶ 0 => "https://dev.avtoshina34.ru/catalog/winter-tyres/Ikon%20(Nokian%20Tyres)/527235" ] "sec-fetch-dest" => array:1 [▶ 0 => "empty" ] "sec-fetch-mode" => array:1 [▶ 0 => "cors" ] "sec-fetch-site" => array:1 [▶ 0 => "same-origin" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "accept" => array:1 [▶ 0 => "text/html, */*; q=0.01" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "x-requested-with" => array:1 [▶ 0 => "XMLHttpRequest" ] "x-csrf-token" => array:1 [▶ 0 => "lw5xqMhxi6Yktk1Pzz5OQOA2iRVhNgWc653j4VCM" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "dev.avtoshina34.ru" ] "content-length" => array:1 [▶ 0 => "" ] "content-type" => array:1 [▶ 0 => "" ] ]
0 of 0array:43 [▶ "USER" => "www-data" "HOME" => "/var/www" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IjZFc0JXc0NuaHlLUjhlWGFudER6ZFE9PSIsInZhbHVlIjoidjk2S1lXYjVFYVc4ZmxGWlNCMzZqSWhlNmJHa3pDNWlDMjdHS1BuWDVSYmtZTFFQa0cxY3dPTDlRUjVvU09jMiIsIm1hYyI6ImNlZDU4NTYxOTQ5YzFjYTk3YzQyODExZDY4MTllMThiMGY5NTNmZWE0NzM0MzQzMzg0MzA5YmYyNjMzZjcyNDUifQ%3D%3D; laravel_session=eyJpdiI6ImpGcWJvTG5cL1piRXh5eWRUZGVReGpRPT0iLCJ2YWx1ZSI6ImdJdG15VFRwaWMwVUtacXZpY2U4MThJTDVubjZcL3JtUmRlT3A4TDB0SGJaYWdBODhSVEV0UUJhT1dybUxUZVwvM002VXN3dGVcL0NKbmNXZWV6NjF0emZ5V2liWEQ0REJhaWNtOUZDS1wvV3NuUThnTDdaZXdZNndjcUwzVFdia1cxMyIsIm1hYyI6ImJhMjhiZWM1M2FlMTEyNzFmZjQ2ODUzYmQ0ZGZlNTFlMGY2NDFlY2MxNzU2YThhZTNjMWVlYjZlZmI2NjNlMGUifQ%3D%3D ◀XSRF-TOKEN=eyJpdiI6IjZFc0JXc0NuaHlLUjhlWGFudER6ZFE9PSIsInZhbHVlIjoidjk2S1lXYjVFYVc4ZmxGWlNCMzZqSWhlNmJHa3pDNWlDMjdHS1BuWDVSYmtZTFFQa0cxY3dPTDlRUjVvU09jMiIsIm1hY ▶" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_REFERER" => "https://dev.avtoshina34.ru/catalog/winter-tyres/Ikon%20(Nokian%20Tyres)/527235" "HTTP_SEC_FETCH_DEST" => "empty" "HTTP_SEC_FETCH_MODE" => "cors" "HTTP_SEC_FETCH_SITE" => "same-origin" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_ACCEPT" => "text/html, */*; q=0.01" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_X_REQUESTED_WITH" => "XMLHttpRequest" "HTTP_X_CSRF_TOKEN" => "lw5xqMhxi6Yktk1Pzz5OQOA2iRVhNgWc653j4VCM" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "HTTP_HOST" => "dev.avtoshina34.ru" "SCRIPT_FILENAME" => "/var/www/avtoshina_beta/public/index.php" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "dev.avtoshina34.ru" "SERVER_PORT" => "443" "SERVER_ADDR" => "89.223.120.242" "REMOTE_PORT" => "1507" "REMOTE_ADDR" => "18.191.229.157" "SERVER_SOFTWARE" => "nginx/1.14.0" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/var/www/avtoshina_beta/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/catalog/getPromoBlock?id=527235" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "id=527235" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1740396808.5867 "REQUEST_TIME" => 1740396808 ]
0 of 0array:2 [▶ "XSRF-TOKEN" => null "laravel_session" => "BW1dQHLXfTBmbtseBLF9ZLlx5EvQHmQQpyx62zfn" ]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 24 Feb 2025 11:33:29 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjJCdGZTVThEOGp0T1VxeUJFT0Z2aHc9PSIsInZhbHVlIjoiWkZVbnZ4M3ZqMzBPbklkS3hpMnFwRG9cL2ZqQ0JcL2lRNHN4YVhkdURXeWJTN3c1T1EwdWZcL1wvUWRCcFFFN05UT28iLCJtYWMiOiI3ZmQwMDQ5ZjJhMWUwNTAwN2E4OGY0MTc2MzZjMmM0MDJmN2RiMzEyY2U3Mzg2YTZhZTM1NmIzZmNiNmYyMGIxIn0%3D; expires=Mon, 24-Feb-2025 13:33:29 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjJCdGZTVThEOGp0T1VxeUJFT0Z2aHc9PSIsInZhbHVlIjoiWkZVbnZ4M3ZqMzBPbklkS3hpMnFwRG9cL2ZqQ0JcL2lRNHN4YVhkdURXeWJTN3c1T1EwdWZcL1wvUWRCcFFFN05UT28iL ▶" 1 => "laravel_session=eyJpdiI6InoxdTU5Tm9nbzZsVUFtM3RyeGJWd0E9PSIsInZhbHVlIjoicjAxcm1Qb0Y0WDh0R1dJWEdYRlFaY1ZkblBZMFpmSEJIYSs0V1ZGa25XUVlqVFArdWdMaVRCOXpOYUp0T0hMXC9YUHppQU5uMnljYnFyTjdVSnpwUm9pQzd0SmxLOTV5VGVTblNRUHA1R2VnZnoyaDhmaXRYaVhVaGNzNVAyNnNuIiwibWFjIjoiMzBjNjU0MWU1Y2UyM2ZkNzVhMDhlOTBkYzcyMjM3ZDc0MzRjZjY3MWUwMzE0NzU0ZTQ5ZTliNTI5NGNlZGEwNSJ9; expires=Mon, 24-Feb-2025 13:33:29 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6InoxdTU5Tm9nbzZsVUFtM3RyeGJWd0E9PSIsInZhbHVlIjoicjAxcm1Qb0Y0WDh0R1dJWEdYRlFaY1ZkblBZMFpmSEJIYSs0V1ZGa25XUVlqVFArdWdMaVRCOXpOYUp0T0hMXC9Y ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjJCdGZTVThEOGp0T1VxeUJFT0Z2aHc9PSIsInZhbHVlIjoiWkZVbnZ4M3ZqMzBPbklkS3hpMnFwRG9cL2ZqQ0JcL2lRNHN4YVhkdURXeWJTN3c1T1EwdWZcL1wvUWRCcFFFN05UT28iLCJtYWMiOiI3ZmQwMDQ5ZjJhMWUwNTAwN2E4OGY0MTc2MzZjMmM0MDJmN2RiMzEyY2U3Mzg2YTZhZTM1NmIzZmNiNmYyMGIxIn0%3D; expires=Mon, 24-Feb-2025 13:33:29 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjJCdGZTVThEOGp0T1VxeUJFT0Z2aHc9PSIsInZhbHVlIjoiWkZVbnZ4M3ZqMzBPbklkS3hpMnFwRG9cL2ZqQ0JcL2lRNHN4YVhkdURXeWJTN3c1T1EwdWZcL1wvUWRCcFFFN05UT28iL ▶" 1 => "laravel_session=eyJpdiI6InoxdTU5Tm9nbzZsVUFtM3RyeGJWd0E9PSIsInZhbHVlIjoicjAxcm1Qb0Y0WDh0R1dJWEdYRlFaY1ZkblBZMFpmSEJIYSs0V1ZGa25XUVlqVFArdWdMaVRCOXpOYUp0T0hMXC9YUHppQU5uMnljYnFyTjdVSnpwUm9pQzd0SmxLOTV5VGVTblNRUHA1R2VnZnoyaDhmaXRYaVhVaGNzNVAyNnNuIiwibWFjIjoiMzBjNjU0MWU1Y2UyM2ZkNzVhMDhlOTBkYzcyMjM3ZDc0MzRjZjY3MWUwMzE0NzU0ZTQ5ZTliNTI5NGNlZGEwNSJ9; expires=Mon, 24-Feb-2025 13:33:29 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InoxdTU5Tm9nbzZsVUFtM3RyeGJWd0E9PSIsInZhbHVlIjoicjAxcm1Qb0Y0WDh0R1dJWEdYRlFaY1ZkblBZMFpmSEJIYSs0V1ZGa25XUVlqVFArdWdMaVRCOXpOYUp0T0hMXC9Y ▶" ] ]
0 of 0array:4 [▶ "_token" => "Z5r8Oy1SXmMAXmhphBB22BG9WLsDieziZ8WgJbWh" "_previous" => array:1 [▶ "url" => "https://dev.avtoshina34.ru/catalog/winter-tyres/Ikon%20(Nokian%20Tyres)/15447" ] "PHPDEBUGBAR_STACK_DATA" => [] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]